Đặt vé xe buýt trực tuyến bằng PHP / MySQLi
1 <script language="javascript">
2 function Clickheretoprint()
3 {
4 var disp_setting="toolbar=yes,location=no,directories=yes,menubar=yes,";
5 disp_setting+="scrollbars=yes,width=800, height=600, left=100, top=25";
6 var content_vlue = document.getElementById("print_content").innerHTML;
7
8 var docprint=window.open("","",disp_setting);
9 docprint.document.open();
10 docprint.document.write('<html><head><title>Inel Power System</title>');
11 docprint.document.write('</head><body onLoad="self.print()" style="width: 400px; font-size:12px; font-family:arial;">');
12 docprint.document.write(content_vlue);
13 docprint.document.write('</body></html>');
14 docprint.document.close();
15 docprint.focus();
16 setTimeout(function(){
17 docprint.close()
18 },750)
19 }
20 </script>
21 Print and present this details upon boarding the bus<br><br>
22 <a href="javascript:Clickheretoprint()">Print</a>
23 <div id="print_content" style="width: 400px;">
24 <strong>Ticket Reservation Details</strong><br><br>
25 <?php
26 include('db.php');
27 $id=$_GET['id'];
28 $setnum=$_GET['setnum'];
29 $result = mysqli_query($conn,"SELECT * FROM customer WHERE transactionum='$id'");
30 while($row = mysqli_fetch_array($result))
31 {
32 echo 'Transaction Number: '.$row['transactionum'].'<br>';
33 echo 'Name: '.$row['fname'].' '.$row['lname'].'<br>';
34 echo 'Address: '.$row['address'].'<br>';
35 echo 'Contact: '.$row['contact'].'<br>';
36 echo 'Payable: '.$row['payable'].'<br>';
37 }
38 $results = mysqli_query($conn,"SELECT * FROM reserve WHERE transactionnum='$id'");
39 while($rows = mysqli_fetch_array($results))
40 {
41 $ggagaga=$rows['bus'];
42 echo 'Route and Type of Bus: ';
43 $resulta = mysqli_query($conn,"SELECT * FROM route WHERE id='$ggagaga'");
44 while($rowa = mysqli_fetch_array($resulta))
45 {
46 echo $rowa['route'].' :'.$rowa['type'];
47 $time=$rowa['time'];
48 }
49 echo 'Time of Departure: '.$time;
50 echo '<br>';
51 echo 'Seat Number: '.$setnum.'<br>';
52 echo 'Date Of Travel: '.$rows['date'].'<br>';
53
54 }
55 ?>
56 </div>
57 <a href="index.php">Home</a>